<?php 
/*
 * Session variables:
 * $_SESSION['database'] [string] = database name of the current tutorial centre
 * $_SESSION['type'] [string] = user type of the logged in user
 * $_SESSION['authorised'] [boolean] = whether or not the current user is logged in
 * $_SESSION['user'] [string] = the username/ email of the logged in user 
 */
session_start();

if(isset($_SESSION['authorised']) && $_SESSION['authorised'] == true)
{
	if(isset($_SESSION['type']))
	{
		if($_SESSION['type'] == 'administrator')
		{
			header('Location: admin_index.php');
			exit();
		}
		elseif($_SESSION['type'] == 'student')
		{
			$host = 'localhost';
			$dbuser = 'postgres';
			$dbpass = 'password';
			$dbname = $_SESSION['database'];
			
			pg_connect("host=$host user=$dbuser password=$dbpass dbname=$dbname") or die(pg_last_error());
			?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Home</title>
<link href="StyleSheet.css" rel="stylesheet" type="text/css" />
<style>
.nav {
	width: 210px;
	height: auto;
	border: thin solid #09C;
	margin-left: 10px;
	text-align: center;
}

.mainline {
	width: 712px;
	height: auto;
	text-align: center;
}
</style>
</head>
<body bgcolor="#FFFFFF">
	<center>

		<div id="wrapper">
			<div id="header">
				<h1></h1>
			</div>

			<div id="header2">
				<h3></h3>
			</div>

			<div id="nav">
				<?php include 'student_navigation.php';?>
			</div>

			<div id="mainline">
				<h4>Class Viewing</h4>
				<div id="body">
					<table width="700" align="right" height="auto"  cellpadding="3" cellspacing="1">
						<tr bgcolor="LightSteelBlue">
							 <tr height="40" bgcolor="LightSteelBlue">
				            <th>Section</th>
							<th>Subject</th>
							<th>Room / Schedule</th>
							<th>Tutor</th>
							<th>Date</th>
						</tr>
						<?php
						$user = $_SESSION['user'];
						$sql = "SELECT * FROM students NATURAL INNER JOIN users WHERE username = '$user'";
						$result = pg_query($sql);
						$student_id = pg_fetch_result($result, 0, 'student_id');
						$sql = "SELECT * FROM enrolled_at WHERE student_id = '$student_id'";
						$result = pg_query($sql);
						$count = pg_num_rows($result);
						if($count<1)
				            {
				            	echo "</table>";
				            	echo "<br><br><br>No classes";
				            }
				            else{
						for ($i = 0; $i < $count; $i++) 
						{
							$class_id = pg_fetch_result($result, $i, 'class_id');
							$sql = "SELECT * FROM classes WHERE class_id = '$class_id'";
							$result = pg_query($sql);
							
							$class_subj = pg_fetch_result($result,0, 'subject');
							$section = pg_fetch_result($result,0, 'section');
							$tutor = pg_fetch_result($result, 0, 'teacher_id');
							$start_date = pg_fetch_result($result, 0, 'startdate');
			                $time = date_create_from_format('Y-m-d', $start_date);
			                $startdate= date_format($time, 'M-d-Y');
							
							$end_date = pg_fetch_result($result, 0, 'enddate');
							$time = date_create_from_format('Y-m-d', $end_date);
			                $enddate= date_format($time, 'M-d-Y');
							$room = pg_fetch_result($result, 'room_id');
							$starttime= pg_fetch_result($result, 'starttime');
							$endtime= pg_fetch_result($result, 'endtime');
							$sql = "SELECT * FROM teachers natural join users where teacher_id='$tutor'";
		           			$result1 = pg_query($sql);
		           			$lastname = pg_fetch_result($result1, 0, 'lastname');
		           			$firstname = pg_fetch_result($result1, 0, 'firstname');
			                echo "<tr height=\"30\" bgcolor=\"#f5f5f5\">
								<td align=\"center\">$section</td>
								<td align=\"center\">$class_subj</td>
								<td align=\"center\">$room / $starttime - $endtime</td>
								<td align=\"center\">$lastname, $firstname</td>
								<td align=\"center\">$startdate to $enddate</td>
							</tr>";
						}
						echo "</table>";
				            }
						?>
					
				</div>
			</div>

			<br class="clearfloat"> <br />

			<div id="footer">
				<p align="center">
					Tutorial Business Manager: info@tbms.com <br />Credits/Engineers:
					Aquino, Chloebelle; Dela Cruz, Roy Erwin; Maliwanag, Ranyel Bryan;
					Manzano, Audrey Ann; Ng, Sheila Regine<br /> <br />copyright 2011
				</p>
			</div>
		</div>
	</center>
</body>
</html>
			<?php
		}
		elseif($_SESSION['type'] == 'tutor')
		{
			header('Location: tutor_index.php');
			exit();
		}
		elseif($_SESSION['type'] == 'parent')
		{
			header('Location: parent_index.php');
			exit();
		}
	}
}
else
{
	header('Location: index.php');
}


?>